﻿USE [TicketAppDBNew]
GO
/****** Object:  Table [dbo].[Addresses]    Script Date: 09/04/2011 16:19:55 ******/
SET IDENTITY_INSERT [dbo].[Addresses] ON
INSERT [dbo].[Addresses] ([Id], [Line1], [Line2], [City], [State], [Country], [PostalCode]) VALUES (1, N'Line1-1', N'Line2-1', N'City-1', N'State-1', N'Country-1', N'111111')
INSERT [dbo].[Addresses] ([Id], [Line1], [Line2], [City], [State], [Country], [PostalCode]) VALUES (2, N'Client-Line1', N'Client-Line2', N'Client-City1', N'Client-State', N'Client-Country1', N'123')
SET IDENTITY_INSERT [dbo].[Addresses] OFF
/****** Object:  Table [dbo].[Events]    Script Date: 09/04/2011 16:19:55 ******/
/****** Object:  Table [dbo].[PaymentModes]    Script Date: 09/04/2011 16:19:55 ******/
/****** Object:  Table [dbo].[Roles]    Script Date: 09/04/2011 16:19:55 ******/
SET IDENTITY_INSERT [dbo].[Roles] ON
INSERT [dbo].[Roles] ([Id], [Name]) VALUES (1, N'Super User')
INSERT [dbo].[Roles] ([Id], [Name]) VALUES (2, N'Client')
INSERT [dbo].[Roles] ([Id], [Name]) VALUES (3, N'Agent')
INSERT [dbo].[Roles] ([Id], [Name]) VALUES (4, N'Website User')
INSERT [dbo].[Roles] ([Id], [Name]) VALUES (5, N'Role1')
INSERT [dbo].[Roles] ([Id], [Name]) VALUES (6, N'Role2')
SET IDENTITY_INSERT [dbo].[Roles] OFF
/****** Object:  Table [dbo].[TicketTemplates]    Script Date: 09/04/2011 16:19:55 ******/
/****** Object:  Table [dbo].[Venues]    Script Date: 09/04/2011 16:19:55 ******/
/****** Object:  Table [dbo].[Users]    Script Date: 09/04/2011 16:19:55 ******/
SET IDENTITY_INSERT [dbo].[Users] ON
INSERT [dbo].[Users] ([Id], [UserName], [Password], [Email], [Phone], [Status], [UserType], [Address_Id], [Role_Id]) VALUES (1, N'vishal', N'anil', N'vishalanil@email.com', N'123456', 1, 1, 1, 1)
INSERT [dbo].[Users] ([Id], [UserName], [Password], [Email], [Phone], [Status], [UserType], [Address_Id], [Role_Id]) VALUES (2, N'Client1', N'Client-password', N'Client1@email.com', N'Client-123', 0, 2, 2, 2)
SET IDENTITY_INSERT [dbo].[Users] OFF
/****** Object:  Table [dbo].[Payments]    Script Date: 09/04/2011 16:19:55 ******/
/****** Object:  Table [dbo].[EventVenues]    Script Date: 09/04/2011 16:19:55 ******/
/****** Object:  Table [dbo].[EventsUsers]    Script Date: 09/04/2011 16:19:55 ******/
/****** Object:  Table [dbo].[AgentBranches]    Script Date: 09/04/2011 16:19:55 ******/
/****** Object:  Table [dbo].[TicketTypes]    Script Date: 09/04/2011 16:19:55 ******/
/****** Object:  Table [dbo].[Tickets]    Script Date: 09/04/2011 16:19:55 ******/
/****** Object:  Table [dbo].[TicketQuotas]    Script Date: 09/04/2011 16:19:55 ******/
